Overview
Brought to you by YData
Dataset statistics
| Number of variables | 15 |
|---|---|
| Number of observations | 10000 |
| Missing cells | 4357 |
| Missing cells (%) | 2.9% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 3.7 MiB |
| Average record size in memory | 387.8 B |
Variable types
| Text | 4 |
|---|---|
| Numeric | 8 |
| Categorical | 3 |
danceability has constant value "0.0" | Constant |
energy has constant value "0.0" | Constant |
artist_familiarity is highly overall correlated with artist_hotttnesss and 1 other fields | High correlation |
artist_hotttnesss is highly overall correlated with artist_familiarity and 1 other fields | High correlation |
song_hotttnesss is highly overall correlated with artist_familiarity and 1 other fields | High correlation |
song_hotttnesss has 4352 (43.5%) missing values | Missing |
track_id has unique values | Unique |
song_id has unique values | Unique |
year has 5320 (53.2%) zeros | Zeros |
key has 1213 (12.1%) zeros | Zeros |
song_hotttnesss has 1434 (14.3%) zeros | Zeros |
artist_hotttnesss has 496 (5.0%) zeros | Zeros |
Reproduction
| Analysis started | 2025-06-24 10:24:23.837352 |
|---|---|
| Analysis finished | 2025-06-24 10:24:30.772032 |
| Duration | 6.93 seconds |
| Software version | ydata-profiling vv4.16.1 |
| Download configuration | config.json |
Variables
track_id
Text
Unique
| Distinct | 10000 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 732.6 KiB |
Length
| Max length | 18 |
|---|---|
| Median length | 18 |
| Mean length | 18 |
| Min length | 18 |
Unique
| Unique | 10000 ? |
|---|---|
| Unique (%) | 100.0% |
Sample
| 1st row | TRBGGLA128F149C2EB |
|---|---|
| 2nd row | TRBGGYE128F42B63AB |
| 3rd row | TRBGGUL128F42ADE30 |
| 4th row | TRBGGRK128F422CA7F |
| 5th row | TRBGGFE128E0785AC0 |
| Value | Count | Frequency (%) |
| trbggla128f149c2eb | 1 | < 0.1% |
| trbggbf128f425e4d1 | 1 | < 0.1% |
| trbgjxw128f42ae7d8 | 1 | < 0.1% |
| trbggul128f42ade30 | 1 | < 0.1% |
| trbggrk128f422ca7f | 1 | < 0.1% |
| trbggfe128e0785ac0 | 1 | < 0.1% |
| trbggru12903caaa2d | 1 | < 0.1% |
| trbggte128f424ecbc | 1 | < 0.1% |
| trbggwq128f42a88cf | 1 | < 0.1% |
| trbggot128f932dc65 | 1 | < 0.1% |
| Other values (9990) | 9990 |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 17708 | 9.8% |
| 1 | 13838 | 7.7% |
| F | 12545 | 7.0% |
| A | 12525 | 7.0% |
| R | 11458 | 6.4% |
| T | 11374 | 6.3% |
| 8 | 11268 | 6.3% |
| 9 | 8335 | 4.6% |
| 3 | 7530 | 4.2% |
| 4 | 7409 | 4.1% |
| Other values (26) | 66010 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 180000 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 2 | 17708 | 9.8% |
| 1 | 13838 | 7.7% |
| F | 12545 | 7.0% |
| A | 12525 | 7.0% |
| R | 11458 | 6.4% |
| T | 11374 | 6.3% |
| 8 | 11268 | 6.3% |
| 9 | 8335 | 4.6% |
| 3 | 7530 | 4.2% |
| 4 | 7409 | 4.1% |
| Other values (26) | 66010 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 180000 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 2 | 17708 | 9.8% |
| 1 | 13838 | 7.7% |
| F | 12545 | 7.0% |
| A | 12525 | 7.0% |
| R | 11458 | 6.4% |
| T | 11374 | 6.3% |
| 8 | 11268 | 6.3% |
| 9 | 8335 | 4.6% |
| 3 | 7530 | 4.2% |
| 4 | 7409 | 4.1% |
| Other values (26) | 66010 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 180000 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 2 | 17708 | 9.8% |
| 1 | 13838 | 7.7% |
| F | 12545 | 7.0% |
| A | 12525 | 7.0% |
| R | 11458 | 6.4% |
| T | 11374 | 6.3% |
| 8 | 11268 | 6.3% |
| 9 | 8335 | 4.6% |
| 3 | 7530 | 4.2% |
| 4 | 7409 | 4.1% |
| Other values (26) | 66010 |
song_id
Text
Unique
| Distinct | 10000 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 732.6 KiB |
Length
| Max length | 18 |
|---|---|
| Median length | 18 |
| Mean length | 18 |
| Min length | 18 |
Unique
| Unique | 10000 ? |
|---|---|
| Unique (%) | 100.0% |
Sample
| 1st row | SOCRVCC12A6D4FB91B |
|---|---|
| 2nd row | SOAPTWU12A8C1409CB |
| 3rd row | SOELHNO12A8C13F09F |
| 4th row | SOVBLUQ12A81C20920 |
| 5th row | SOGDAUG12A6701F302 |
| Value | Count | Frequency (%) |
| socrvcc12a6d4fb91b | 1 | < 0.1% |
| sobehxg12a8c138d22 | 1 | < 0.1% |
| soqznyw12a8c1411b3 | 1 | < 0.1% |
| soelhno12a8c13f09f | 1 | < 0.1% |
| sovbluq12a81c20920 | 1 | < 0.1% |
| sogdaug12a6701f302 | 1 | < 0.1% |
| sobbyxe12a58a772b2 | 1 | < 0.1% |
| souuqxl12a8c1339fe | 1 | < 0.1% |
| sootbsz12a8c140223 | 1 | < 0.1% |
| solbvsr12ab0183e1a | 1 | < 0.1% |
| Other values (9990) | 9990 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 18948 | 10.5% |
| A | 16004 | 8.9% |
| 2 | 13004 | 7.2% |
| O | 11893 | 6.6% |
| S | 11815 | 6.6% |
| 8 | 9829 | 5.5% |
| C | 8079 | 4.5% |
| B | 8025 | 4.5% |
| 0 | 6020 | 3.3% |
| F | 6012 | 3.3% |
| Other values (26) | 70371 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 180000 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 1 | 18948 | 10.5% |
| A | 16004 | 8.9% |
| 2 | 13004 | 7.2% |
| O | 11893 | 6.6% |
| S | 11815 | 6.6% |
| 8 | 9829 | 5.5% |
| C | 8079 | 4.5% |
| B | 8025 | 4.5% |
| 0 | 6020 | 3.3% |
| F | 6012 | 3.3% |
| Other values (26) | 70371 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 180000 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 1 | 18948 | 10.5% |
| A | 16004 | 8.9% |
| 2 | 13004 | 7.2% |
| O | 11893 | 6.6% |
| S | 11815 | 6.6% |
| 8 | 9829 | 5.5% |
| C | 8079 | 4.5% |
| B | 8025 | 4.5% |
| 0 | 6020 | 3.3% |
| F | 6012 | 3.3% |
| Other values (26) | 70371 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 180000 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 1 | 18948 | 10.5% |
| A | 16004 | 8.9% |
| 2 | 13004 | 7.2% |
| O | 11893 | 6.6% |
| S | 11815 | 6.6% |
| 8 | 9829 | 5.5% |
| C | 8079 | 4.5% |
| B | 8025 | 4.5% |
| 0 | 6020 | 3.3% |
| F | 6012 | 3.3% |
| Other values (26) | 70371 |
title
Text
| Distinct | 9708 |
|---|---|
| Distinct (%) | 97.1% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Memory size | 763.5 KiB |
Length
| Max length | 174 |
|---|---|
| Median length | 98 |
| Mean length | 19.446745 |
| Min length | 1 |
Unique
| Unique | 9483 ? |
|---|---|
| Unique (%) | 94.8% |
Sample
| 1st row | The Urban Gospel |
|---|---|
| 2nd row | See What Tomorrow Brings |
| 3rd row | Ela Edo Kardia Mou |
| 4th row | Laakista humppa |
| 5th row | Coral Fang (Album Version) |
| Value | Count | Frequency (%) |
| the | 1296 | 3.6% |
| version | 773 | 2.2% |
| you | 494 | 1.4% |
| album | 466 | 1.3% |
| of | 448 | 1.3% |
| a | 437 | 1.2% |
| 414 | 1.2% | |
| in | 409 | 1.2% |
| i | 392 | 1.1% |
| me | 349 | 1.0% |
| Other values (9939) | 30036 |
Most occurring characters
| Value | Count | Frequency (%) |
| 25590 | 13.2% | |
| e | 17668 | 9.1% |
| o | 11705 | 6.0% |
| a | 11139 | 5.7% |
| i | 10338 | 5.3% |
| n | 10276 | 5.3% |
| r | 9120 | 4.7% |
| t | 7822 | 4.0% |
| s | 6980 | 3.6% |
| l | 6720 | 3.5% |
| Other values (124) | 77090 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 194448 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 25590 | 13.2% | |
| e | 17668 | 9.1% |
| o | 11705 | 6.0% |
| a | 11139 | 5.7% |
| i | 10338 | 5.3% |
| n | 10276 | 5.3% |
| r | 9120 | 4.7% |
| t | 7822 | 4.0% |
| s | 6980 | 3.6% |
| l | 6720 | 3.5% |
| Other values (124) | 77090 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 194448 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 25590 | 13.2% | |
| e | 17668 | 9.1% |
| o | 11705 | 6.0% |
| a | 11139 | 5.7% |
| i | 10338 | 5.3% |
| n | 10276 | 5.3% |
| r | 9120 | 4.7% |
| t | 7822 | 4.0% |
| s | 6980 | 3.6% |
| l | 6720 | 3.5% |
| Other values (124) | 77090 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 194448 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 25590 | 13.2% | |
| e | 17668 | 9.1% |
| o | 11705 | 6.0% |
| a | 11139 | 5.7% |
| i | 10338 | 5.3% |
| n | 10276 | 5.3% |
| r | 9120 | 4.7% |
| t | 7822 | 4.0% |
| s | 6980 | 3.6% |
| l | 6720 | 3.5% |
| Other values (124) | 77090 |
artist_name
Text
| Distinct | 4412 |
|---|---|
| Distinct (%) | 44.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 699.7 KiB |
Length
| Max length | 255 |
|---|---|
| Median length | 137 |
| Mean length | 13.3689 |
| Min length | 1 |
Unique
| Unique | 2163 ? |
|---|---|
| Unique (%) | 21.6% |
Sample
| 1st row | Shade Sheist / N.U.N.E. / King Arthur |
|---|---|
| 2nd row | Arc Angels |
| 3rd row | Irini Merkouri |
| 4th row | Elakelaiset |
| 5th row | The Distillers |
| Value | Count | Frequency (%) |
| the | 885 | 4.0% |
| 455 | 2.1% | |
| john | 127 | 0.6% |
| and | 123 | 0.6% |
| of | 116 | 0.5% |
| band | 93 | 0.4% |
| featuring | 87 | 0.4% |
| orchestra | 84 | 0.4% |
| los | 80 | 0.4% |
| dj | 78 | 0.4% |
| Other values (5885) | 19993 |
Most occurring characters
| Value | Count | Frequency (%) |
| 12123 | 9.1% | |
| e | 12072 | 9.0% |
| a | 10593 | 7.9% |
| i | 8152 | 6.1% |
| n | 7882 | 5.9% |
| r | 7794 | 5.8% |
| o | 7697 | 5.8% |
| s | 5832 | 4.4% |
| l | 5807 | 4.3% |
| t | 4855 | 3.6% |
| Other values (93) | 50882 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 133689 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 12123 | 9.1% | |
| e | 12072 | 9.0% |
| a | 10593 | 7.9% |
| i | 8152 | 6.1% |
| n | 7882 | 5.9% |
| r | 7794 | 5.8% |
| o | 7697 | 5.8% |
| s | 5832 | 4.4% |
| l | 5807 | 4.3% |
| t | 4855 | 3.6% |
| Other values (93) | 50882 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 133689 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 12123 | 9.1% | |
| e | 12072 | 9.0% |
| a | 10593 | 7.9% |
| i | 8152 | 6.1% |
| n | 7882 | 5.9% |
| r | 7794 | 5.8% |
| o | 7697 | 5.8% |
| s | 5832 | 4.4% |
| l | 5807 | 4.3% |
| t | 4855 | 3.6% |
| Other values (93) | 50882 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 133689 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 12123 | 9.1% | |
| e | 12072 | 9.0% |
| a | 10593 | 7.9% |
| i | 8152 | 6.1% |
| n | 7882 | 5.9% |
| r | 7794 | 5.8% |
| o | 7697 | 5.8% |
| s | 5832 | 4.4% |
| l | 5807 | 4.3% |
| t | 4855 | 3.6% |
| Other values (93) | 50882 |
year
Real number (ℝ)
Zeros
| Distinct | 69 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 934.7046 |
| Minimum | 0 |
|---|---|
| Maximum | 2010 |
| Zeros | 5320 |
| Zeros (%) | 53.2% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 78.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 2000 |
| 95-th percentile | 2008 |
| Maximum | 2010 |
| Range | 2010 |
| Interquartile range (IQR) | 2000 |
Descriptive statistics
| Standard deviation | 996.65066 |
|---|---|
| Coefficient of variation (CV) | 1.0662734 |
| Kurtosis | -1.9836379 |
| Mean | 934.7046 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 0.12847432 |
| Sum | 9347046 |
| Variance | 993312.53 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 5320 | |
| 2006 | 320 | 3.2% |
| 2005 | 304 | 3.0% |
| 2007 | 285 | 2.9% |
| 2004 | 270 | 2.7% |
| 2003 | 254 | 2.5% |
| 2008 | 253 | 2.5% |
| 2009 | 250 | 2.5% |
| 2001 | 217 | 2.2% |
| 2002 | 198 | 2.0% |
| Other values (59) | 2329 |
| Value | Count | Frequency (%) |
| 0 | 5320 | |
| 1926 | 2 | < 0.1% |
| 1927 | 3 | < 0.1% |
| 1929 | 1 | < 0.1% |
| 1930 | 2 | < 0.1% |
| 1934 | 1 | < 0.1% |
| 1935 | 2 | < 0.1% |
| 1936 | 1 | < 0.1% |
| 1940 | 2 | < 0.1% |
| 1947 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 2010 | 64 | 0.6% |
| 2009 | 250 | |
| 2008 | 253 | |
| 2007 | 285 | |
| 2006 | 320 | |
| 2005 | 304 | |
| 2004 | 270 | |
| 2003 | 254 | |
| 2002 | 198 | |
| 2001 | 217 |
duration
Real number (ℝ)
| Distinct | 6553 |
|---|---|
| Distinct (%) | 65.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 238.50752 |
| Minimum | 1.04444 |
|---|---|
| Maximum | 1819.7677 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 78.3 KiB |
Quantile statistics
| Minimum | 1.04444 |
|---|---|
| 5-th percentile | 105.67922 |
| Q1 | 176.0322 |
| median | 223.05914 |
| Q3 | 276.37506 |
| 95-th percentile | 421.63285 |
| Maximum | 1819.7677 |
| Range | 1818.7233 |
| Interquartile range (IQR) | 100.34286 |
Descriptive statistics
| Standard deviation | 114.13751 |
|---|---|
| Coefficient of variation (CV) | 0.47854891 |
| Kurtosis | 27.433082 |
| Mean | 238.50752 |
| Median Absolute Deviation (MAD) | 49.763265 |
| Skewness | 3.3796728 |
| Sum | 2385075.2 |
| Variance | 13027.372 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 222.14485 | 8 | 0.1% |
| 216.81587 | 8 | 0.1% |
| 181.39383 | 7 | 0.1% |
| 229.51138 | 7 | 0.1% |
| 232.202 | 7 | 0.1% |
| 187.24526 | 6 | 0.1% |
| 267.59791 | 6 | 0.1% |
| 249.93914 | 6 | 0.1% |
| 230.37342 | 6 | 0.1% |
| 151.09179 | 6 | 0.1% |
| Other values (6543) | 9933 |
| Value | Count | Frequency (%) |
| 1.04444 | 1 | |
| 1.2273 | 1 | |
| 3.5522 | 1 | |
| 3.99628 | 1 | |
| 6.08608 | 1 | |
| 7.13098 | 1 | |
| 9.66485 | 1 | |
| 10.34404 | 1 | |
| 10.65751 | 1 | |
| 10.68363 | 1 |
| Value | Count | Frequency (%) |
| 1819.76771 | 1 | |
| 1815.2224 | 1 | |
| 1686.7522 | 1 | |
| 1610.00444 | 1 | |
| 1598.1971 | 1 | |
| 1519.28118 | 1 | |
| 1400.37179 | 1 | |
| 1394.75546 | 1 | |
| 1280.88771 | 1 | |
| 1280.522 | 1 |
tempo
Real number (ℝ)
| Distinct | 9336 |
|---|---|
| Distinct (%) | 93.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 122.91545 |
| Minimum | 0 |
|---|---|
| Maximum | 262.828 |
| Zeros | 25 |
| Zeros (%) | 0.2% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 78.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 74.14925 |
| Q1 | 96.96575 |
| median | 120.161 |
| Q3 | 144.01325 |
| 95-th percentile | 186.5015 |
| Maximum | 262.828 |
| Range | 262.828 |
| Interquartile range (IQR) | 47.0475 |
Descriptive statistics
| Standard deviation | 35.184412 |
|---|---|
| Coefficient of variation (CV) | 0.2862489 |
| Kurtosis | 0.4711858 |
| Mean | 122.91545 |
| Median Absolute Deviation (MAD) | 23.526 |
| Skewness | 0.4112324 |
| Sum | 1229154.5 |
| Variance | 1237.9428 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 25 | 0.2% |
| 131.991 | 5 | 0.1% |
| 120.006 | 4 | < 0.1% |
| 128.006 | 4 | < 0.1% |
| 85.006 | 4 | < 0.1% |
| 131.999 | 4 | < 0.1% |
| 96.002 | 4 | < 0.1% |
| 117.298 | 4 | < 0.1% |
| 99.995 | 4 | < 0.1% |
| 96.007 | 4 | < 0.1% |
| Other values (9326) | 9938 |
| Value | Count | Frequency (%) |
| 0 | 25 | |
| 16.258 | 1 | < 0.1% |
| 19.657 | 1 | < 0.1% |
| 21.438 | 1 | < 0.1% |
| 26.663 | 1 | < 0.1% |
| 27.163 | 1 | < 0.1% |
| 30.048 | 1 | < 0.1% |
| 30.553 | 1 | < 0.1% |
| 30.827 | 1 | < 0.1% |
| 32.239 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 262.828 | 1 | |
| 258.677 | 1 | |
| 253.357 | 1 | |
| 248.079 | 1 | |
| 246.593 | 1 | |
| 246.5 | 1 | |
| 244.366 | 1 | |
| 244.268 | 1 | |
| 243.994 | 1 | |
| 243.981 | 1 |
key
Real number (ℝ)
Zeros
| Distinct | 12 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5.2761 |
| Minimum | 0 |
|---|---|
| Maximum | 11 |
| Zeros | 1213 |
| Zeros (%) | 12.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 78.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 2 |
| median | 5 |
| Q3 | 8 |
| 95-th percentile | 11 |
| Maximum | 11 |
| Range | 11 |
| Interquartile range (IQR) | 6 |
Descriptive statistics
| Standard deviation | 3.5540867 |
|---|---|
| Coefficient of variation (CV) | 0.67362003 |
| Kurtosis | -1.2844363 |
| Mean | 5.2761 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | -0.0083689462 |
| Sum | 52761 |
| Variance | 12.631532 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=12)
| Value | Count | Frequency (%) |
| 7 | 1339 | |
| 0 | 1213 | |
| 2 | 1129 | |
| 9 | 1040 | |
| 1 | 821 | |
| 4 | 810 | |
| 5 | 795 | |
| 11 | 738 | |
| 10 | 700 | |
| 6 | 577 | |
| Other values (2) | 838 |
| Value | Count | Frequency (%) |
| 0 | 1213 | |
| 1 | 821 | |
| 2 | 1129 | |
| 3 | 310 | 3.1% |
| 4 | 810 | |
| 5 | 795 | |
| 6 | 577 | |
| 7 | 1339 | |
| 8 | 528 | 5.3% |
| 9 | 1040 |
| Value | Count | Frequency (%) |
| 11 | 738 | |
| 10 | 700 | |
| 9 | 1040 | |
| 8 | 528 | 5.3% |
| 7 | 1339 | |
| 6 | 577 | |
| 5 | 795 | |
| 4 | 810 | |
| 3 | 310 | 3.1% |
| 2 | 1129 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 1 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 1 | 6911 | |
| 0 | 3089 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1 | 6911 | |
| 0 | 3089 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 6911 | |
| 0 | 3089 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 10000 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 1 | 6911 | |
| 0 | 3089 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 10000 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 1 | 6911 | |
| 0 | 3089 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 10000 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 1 | 6911 | |
| 0 | 3089 |
loudness
Real number (ℝ)
| Distinct | 7435 |
|---|---|
| Distinct (%) | 74.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -10.485668 |
| Minimum | -51.643 |
|---|---|
| Maximum | 0.566 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 9999 |
| Negative (%) | > 99.9% |
| Memory size | 78.3 KiB |
Quantile statistics
| Minimum | -51.643 |
|---|---|
| 5-th percentile | -20.93115 |
| Q1 | -13.16325 |
| median | -9.38 |
| Q3 | -6.5325 |
| 95-th percentile | -4.02185 |
| Maximum | 0.566 |
| Range | 52.209 |
| Interquartile range (IQR) | 6.63075 |
Descriptive statistics
| Standard deviation | 5.3997882 |
|---|---|
| Coefficient of variation (CV) | -0.51496843 |
| Kurtosis | 2.8625648 |
| Mean | -10.485668 |
| Median Absolute Deviation (MAD) | 3.204 |
| Skewness | -1.357837 |
| Sum | -104856.69 |
| Variance | 29.157713 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| -6.748 | 6 | 0.1% |
| -7.736 | 6 | 0.1% |
| -13.615 | 5 | 0.1% |
| -6.53 | 5 | 0.1% |
| -5.75 | 5 | 0.1% |
| -12.256 | 5 | 0.1% |
| -10.7 | 5 | 0.1% |
| -6.947 | 5 | 0.1% |
| -9.224 | 5 | 0.1% |
| -9.464 | 5 | 0.1% |
| Other values (7425) | 9948 |
| Value | Count | Frequency (%) |
| -51.643 | 1 | |
| -47.664 | 1 | |
| -42.472 | 1 | |
| -41.806 | 1 | |
| -41.691 | 1 | |
| -39.325 | 1 | |
| -38.525 | 1 | |
| -38.148 | 1 | |
| -37.668 | 1 | |
| -37.456 | 1 |
| Value | Count | Frequency (%) |
| 0.566 | 1 | |
| -1.026 | 1 | |
| -1.031 | 1 | |
| -1.217 | 1 | |
| -1.479 | 1 | |
| -1.493 | 1 | |
| -1.545 | 1 | |
| -1.622 | 1 | |
| -1.651 | 1 | |
| -1.672 | 1 |
danceability
Categorical
Constant
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 586.1 KiB |
| 0.0 |
|---|
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0.0 |
|---|---|
| 2nd row | 0.0 |
| 3rd row | 0.0 |
| 4th row | 0.0 |
| 5th row | 0.0 |
Common Values
| Value | Count | Frequency (%) |
| 0.0 | 10000 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0.0 | 10000 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 20000 | |
| . | 10000 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 30000 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 20000 | |
| . | 10000 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 30000 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 20000 | |
| . | 10000 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 30000 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 20000 | |
| . | 10000 |
energy
Categorical
Constant
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 586.1 KiB |
| 0.0 |
|---|
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0.0 |
|---|---|
| 2nd row | 0.0 |
| 3rd row | 0.0 |
| 4th row | 0.0 |
| 5th row | 0.0 |
Common Values
| Value | Count | Frequency (%) |
| 0.0 | 10000 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0.0 | 10000 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 20000 | |
| . | 10000 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 30000 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 20000 | |
| . | 10000 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 30000 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 20000 | |
| . | 10000 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 30000 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 20000 | |
| . | 10000 |
song_hotttnesss
Real number (ℝ)
High correlation Missing Zeros
| Distinct | 1919 |
|---|---|
| Distinct (%) | 34.0% |
| Missing | 4352 |
| Missing (%) | 43.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.3428217 |
| Minimum | 0 |
|---|---|
| Maximum | 1 |
| Zeros | 1434 |
| Zeros (%) | 14.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 78.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0.36037058 |
| Q3 | 0.5375039 |
| 95-th percentile | 0.72138646 |
| Maximum | 1 |
| Range | 1 |
| Interquartile range (IQR) | 0.5375039 |
Descriptive statistics
| Standard deviation | 0.24721972 |
|---|---|
| Coefficient of variation (CV) | 0.72113207 |
| Kurtosis | -1.0408618 |
| Mean | 0.3428217 |
| Median Absolute Deviation (MAD) | 0.18115191 |
| Skewness | -0.029362954 |
| Sum | 1936.257 |
| Variance | 0.06111759 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 1434 | 14.3% |
| 0.2658610492 | 140 | 1.4% |
| 0.2150803185 | 123 | 1.2% |
| 0.3347065491 | 91 | 0.9% |
| 0.2120454055 | 76 | 0.8% |
| 0.2707759989 | 68 | 0.7% |
| 0.3759843015 | 65 | 0.7% |
| 0.3041695034 | 52 | 0.5% |
| 0.2669551863 | 50 | 0.5% |
| 0.4051157217 | 45 | 0.4% |
| Other values (1909) | 3504 | |
| (Missing) | 4352 |
| Value | Count | Frequency (%) |
| 0 | 1434 | |
| 0.1878949793 | 1 | < 0.1% |
| 0.1903996306 | 1 | < 0.1% |
| 0.19065616 | 1 | < 0.1% |
| 0.1912999416 | 1 | < 0.1% |
| 0.1922477612 | 1 | < 0.1% |
| 0.1922643816 | 1 | < 0.1% |
| 0.1926477122 | 1 | < 0.1% |
| 0.1927269163 | 1 | < 0.1% |
| 0.1928563461 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 1 | 2 | |
| 0.9977583963 | 1 | |
| 0.9843467385 | 1 | |
| 0.9798371965 | 1 | |
| 0.9723868908 | 1 | |
| 0.9459946798 | 1 | |
| 0.9322741632 | 1 | |
| 0.9313464883 | 1 | |
| 0.9286168419 | 1 | |
| 0.9283671134 | 1 |
artist_hotttnesss
Real number (ℝ)
High correlation Zeros
| Distinct | 3714 |
|---|---|
| Distinct (%) | 37.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.3855522 |
| Minimum | 0 |
|---|---|
| Maximum | 1.0825026 |
| Zeros | 496 |
| Zeros (%) | 5.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 78.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0.049034381 |
| Q1 | 0.32526565 |
| median | 0.38074233 |
| Q3 | 0.45385807 |
| 95-th percentile | 0.60118606 |
| Maximum | 1.0825026 |
| Range | 1.0825026 |
| Interquartile range (IQR) | 0.12859243 |
Descriptive statistics
| Standard deviation | 0.1436473 |
|---|---|
| Coefficient of variation (CV) | 0.37257548 |
| Kurtosis | 2.5157572 |
| Mean | 0.3855522 |
| Median Absolute Deviation (MAD) | 0.062897272 |
| Skewness | -0.15228458 |
| Sum | 3855.522 |
| Variance | 0.020634547 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 496 | 5.0% |
| 0.04903438085 | 13 | 0.1% |
| 0.6066301517 | 12 | 0.1% |
| 0.3862896512 | 12 | 0.1% |
| 0.6672945956 | 12 | 0.1% |
| 0.3200869268 | 12 | 0.1% |
| 0.3114376403 | 12 | 0.1% |
| 0.4794076756 | 11 | 0.1% |
| 0.5442575057 | 11 | 0.1% |
| 0.3604457658 | 11 | 0.1% |
| Other values (3704) | 9398 |
| Value | Count | Frequency (%) |
| 0 | 496 | |
| 0.01156180408 | 1 | < 0.1% |
| 0.03530794717 | 2 | < 0.1% |
| 0.04903438085 | 13 | 0.1% |
| 0.05018763941 | 2 | < 0.1% |
| 0.06372498646 | 6 | 0.1% |
| 0.0778420103 | 1 | < 0.1% |
| 0.08016693866 | 10 | 0.1% |
| 0.08229222642 | 1 | < 0.1% |
| 0.08999872435 | 3 | < 0.1% |
| Value | Count | Frequency (%) |
| 1.082502557 | 9 | |
| 1.021255587 | 1 | < 0.1% |
| 1.005941966 | 5 | |
| 0.9224124434 | 1 | < 0.1% |
| 0.9160532283 | 6 | |
| 0.9082026192 | 8 | |
| 0.8792367447 | 2 | < 0.1% |
| 0.8728389206 | 2 | < 0.1% |
| 0.8724472232 | 1 | < 0.1% |
| 0.8546378282 | 6 |
artist_familiarity
Real number (ℝ)
High correlation
| Distinct | 4047 |
|---|---|
| Distinct (%) | 40.5% |
| Missing | 4 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.56545571 |
| Minimum | 0 |
|---|---|
| Maximum | 1 |
| Zeros | 20 |
| Zeros (%) | 0.2% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 78.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0.32184343 |
| Q1 | 0.46761116 |
| median | 0.56366611 |
| Q3 | 0.66802025 |
| 95-th percentile | 0.83927539 |
| Maximum | 1 |
| Range | 1 |
| Interquartile range (IQR) | 0.20040909 |
Descriptive statistics
| Standard deviation | 0.16016126 |
|---|---|
| Coefficient of variation (CV) | 0.2832428 |
| Kurtosis | 0.64489319 |
| Mean | 0.56545571 |
| Median Absolute Deviation (MAD) | 0.099232076 |
| Skewness | -0.2577576 |
| Sum | 5652.2952 |
| Variance | 0.025651628 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 20 | 0.2% |
| 0.3345427837 | 13 | 0.1% |
| 0.4702122957 | 12 | 0.1% |
| 0.6869889546 | 12 | 0.1% |
| 0.6069757372 | 12 | 0.1% |
| 0.323008991 | 12 | 0.1% |
| 0.8725365987 | 12 | 0.1% |
| 0.8183193591 | 12 | 0.1% |
| 0.5856831498 | 11 | 0.1% |
| 0.8999349522 | 11 | 0.1% |
| Other values (4037) | 9869 |
| Value | Count | Frequency (%) |
| 0 | 20 | |
| 0.01555788068 | 3 | < 0.1% |
| 0.0185015424 | 2 | < 0.1% |
| 0.01855509301 | 1 | < 0.1% |
| 0.01891756723 | 2 | < 0.1% |
| 0.01963088808 | 1 | < 0.1% |
| 0.02108265603 | 1 | < 0.1% |
| 0.02149290542 | 7 | 0.1% |
| 0.02166644617 | 1 | < 0.1% |
| 0.02255650052 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 1 | 4 | |
| 0.9899385697 | 1 | < 0.1% |
| 0.951487818 | 1 | < 0.1% |
| 0.9473275066 | 9 | |
| 0.9418964545 | 2 | < 0.1% |
| 0.9392271646 | 1 | < 0.1% |
| 0.9379647504 | 5 | |
| 0.9349352674 | 7 | |
| 0.9339161064 | 5 | |
| 0.9290302874 | 7 |
Interactions
Correlations
| artist_familiarity | artist_hotttnesss | duration | key | loudness | mode | song_hotttnesss | tempo | year | |
|---|---|---|---|---|---|---|---|---|---|
| artist_familiarity | 1.000 | 0.860 | 0.083 | 0.038 | 0.278 | 0.021 | 0.566 | 0.063 | 0.398 |
| artist_hotttnesss | 0.860 | 1.000 | 0.076 | 0.031 | 0.233 | 0.023 | 0.556 | 0.054 | 0.387 |
| duration | 0.083 | 0.076 | 1.000 | 0.027 | 0.138 | 0.066 | 0.044 | 0.013 | 0.053 |
| key | 0.038 | 0.031 | 0.027 | 1.000 | 0.057 | 0.289 | 0.027 | 0.009 | 0.002 |
| loudness | 0.278 | 0.233 | 0.138 | 0.057 | 1.000 | 0.062 | 0.259 | 0.172 | 0.223 |
| mode | 0.021 | 0.023 | 0.066 | 0.289 | 0.062 | 1.000 | 0.017 | 0.000 | 0.008 |
| song_hotttnesss | 0.566 | 0.556 | 0.044 | 0.027 | 0.259 | 0.017 | 1.000 | 0.083 | 0.435 |
| tempo | 0.063 | 0.054 | 0.013 | 0.009 | 0.172 | 0.000 | 0.083 | 1.000 | 0.055 |
| year | 0.398 | 0.387 | 0.053 | 0.002 | 0.223 | 0.008 | 0.435 | 0.055 | 1.000 |
Missing values
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.
Sample
| track_id | song_id | title | artist_name | year | duration | tempo | key | mode | loudness | danceability | energy | song_hotttnesss | artist_hotttnesss | artist_familiarity | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | TRBGGLA128F149C2EB | SOCRVCC12A6D4FB91B | The Urban Gospel | Shade Sheist / N.U.N.E. / King Arthur | 0 | 262.34730 | 89.912 | 11 | 0 | -7.673 | 0.0 | 0.0 | 0.000000 | 0.346136 | 0.553284 |
| 1 | TRBGGYE128F42B63AB | SOAPTWU12A8C1409CB | See What Tomorrow Brings | Arc Angels | 1992 | 386.79465 | 125.787 | 8 | 1 | -10.118 | 0.0 | 0.0 | 0.473347 | 0.349366 | 0.588932 |
| 2 | TRBGGUL128F42ADE30 | SOELHNO12A8C13F09F | Ela Edo Kardia Mou | Irini Merkouri | 0 | 228.33587 | 155.979 | 3 | 0 | -6.252 | 0.0 | 0.0 | NaN | 0.000000 | 0.396304 |
| 3 | TRBGGRK128F422CA7F | SOVBLUQ12A81C20920 | Laakista humppa | Elakelaiset | 1995 | 67.31710 | 116.338 | 9 | 0 | -2.421 | 0.0 | 0.0 | NaN | 0.405143 | 0.508440 |
| 4 | TRBGGFE128E0785AC0 | SOGDAUG12A6701F302 | Coral Fang (Album Version) | The Distillers | 2003 | 129.59302 | 95.075 | 9 | 0 | -3.698 | 0.0 | 0.0 | 0.360371 | 0.488536 | 0.681091 |
| 5 | TRBGGRU12903CAAA2D | SOBBYXE12A58A772B2 | He Don't Care (He's Stoned) | Dan Hicks | 0 | 159.94730 | 72.357 | 0 | 1 | -32.535 | 0.0 | 0.0 | 0.000000 | 0.383357 | 0.594138 |
| 6 | TRBGGTE128F424ECBC | SOUUQXL12A8C1339FE | One More Time (Kennedy Center Homecoming Version) | The Katinas | 0 | 159.26812 | 80.945 | 0 | 0 | -10.599 | 0.0 | 0.0 | 0.000000 | 0.438933 | 0.606901 |
| 7 | TRBGGWQ128F42A88CF | SOOTBSZ12A8C140223 | Rich Girl | Daryl Hall & John Oates | 1976 | 216.34567 | 178.825 | 10 | 1 | -5.745 | 0.0 | 0.0 | NaN | 0.496381 | 0.664924 |
| 8 | TRBGGBF128F425E4D1 | SOBEHXG12A8C138D22 | Rumour (Abstract Hip Hop Mix) | bel canto | 1996 | 78.49751 | 106.936 | 7 | 1 | -17.795 | 0.0 | 0.0 | 0.345802 | 0.368252 | 0.572338 |
| 9 | TRBGGOT128F932DC65 | SOLBVSR12AB0183E1A | 18 De Noviembre | Maracaibo 15 | 0 | 171.98975 | 181.002 | 2 | 1 | -8.002 | 0.0 | 0.0 | 0.299877 | 0.314700 | 0.433954 |
| track_id | song_id | title | artist_name | year | duration | tempo | key | mode | loudness | danceability | energy | song_hotttnesss | artist_hotttnesss | artist_familiarity | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9990 | TRAFFEM128F42A2223 | SOQCUBJ12A8C13FEC6 | The Sirius Deception (Album Version) | Nicholas Hooper | 0 | 154.38322 | 98.509 | 1 | 1 | -19.751 | 0.0 | 0.0 | 0.000000 | 0.435808 | 0.572943 |
| 9991 | TRAFFPR128F421A35F | SOPRNQZ12A58A7B8E5 | Spaz's House Destruction Party | Anti-Flag | 2001 | 184.05832 | 131.121 | 1 | 1 | -6.547 | 0.0 | 0.0 | 0.594362 | 0.524379 | 0.844040 |
| 9992 | TRAFFSE128F429FB8D | SOCIFJJ12A8C13F98C | This Heart Of Mine | Josh White | 0 | 178.75546 | 163.083 | 4 | 0 | -21.858 | 0.0 | 0.0 | 0.000000 | 0.351023 | 0.490586 |
| 9993 | TRAFFDW12903CE53B6 | SOJGCBK12AB01884D3 | Say What!?! | Chris Standring | 2003 | 269.32200 | 140.044 | 0 | 1 | -9.041 | 0.0 | 0.0 | 0.511424 | 0.415938 | 0.564710 |
| 9994 | TRAFFEE12903CC04B4 | SORRHKT12AB0186469 | Blott En Dag | Mons Leidvin Takle | 2001 | 180.37506 | 60.509 | 7 | 1 | -16.067 | 0.0 | 0.0 | NaN | 0.282402 | 0.221726 |
| 9995 | TRAFFEQ12903CF4356 | SOHFNIA12AC4689741 | Catharsis Of A Heretic | The Ocean | 2010 | 128.83546 | 139.972 | 5 | 0 | -8.966 | 0.0 | 0.0 | 0.626464 | 0.465500 | 0.636419 |
| 9996 | TRAFFCC128F9348D0D | SOCMBTX12AB0181E7E | Una Sopita De Tu Propio Chocolate | Angélica María | 1997 | 171.23220 | 114.045 | 0 | 1 | -11.101 | 0.0 | 0.0 | NaN | 0.309902 | 0.437890 |
| 9997 | TRAFFRG128F421BD23 | SOPMFLZ12A6D4F9D3A | Mai [Live] | Josh Groban | 2008 | 282.85342 | 125.958 | 9 | 1 | -7.341 | 0.0 | 0.0 | 0.520527 | 0.755150 | 0.765357 |
| 9998 | TRAFFIW128F4236391 | SOZUQAZ12A81C21E0D | Verdad Amarga | Los Solitarios | 0 | 168.12363 | 94.994 | 5 | 0 | -14.058 | 0.0 | 0.0 | 0.235714 | 0.299113 | 0.488161 |
| 9999 | TRAFFKV12903CE29B5 | SOJFIUP12AB0187346 | Your Love | Glen Washington | 0 | 234.68363 | 102.605 | 5 | 0 | -14.213 | 0.0 | 0.0 | NaN | 0.301247 | 0.512740 |